"""
Case Type   : 系统内部使用工具
Case Name   : gs_ctl start只使用-D指定正确数据库实例目录启动备机
Create At   : 2021/01/15
Owner       : opentestcase015
Description :
    1.关闭正在运行的备机
    2.指定正确数据库实例目录启动备机
    3.查看集群状态
    4.恢复环境，启动备机
Expect      :
    1.关闭正在运行的备机成功
    2.指定正确数据库实例目录启动备机成功
    3.查看集群状态备机启动成功
    4.成功
History     :
    Modified by lopentestcase027 2023/1/9: 优化用例步骤格式及一主两备判断方式
    Modified by lopentestcase027 2023/5/6: step3查看集群状态前增加等待时间，待备机完成xlog
                                     redo,walreceiver发起连接后查看状态
"""

import unittest
import os
import time
from testcase.utils.Constant import Constant
from testcase.utils.CommonSH import CommonSH
from testcase.utils.Logger import Logger
from yat.test import Node
from yat.test import macro

LOG = Logger()
primary_sh = CommonSH('PrimaryDbUser')


@unittest.skipIf(3 != primary_sh.get_node_num(), '非1+2环境不执行')
class LogicalReplication(unittest.TestCase):
    def setUp(self):
        LOG.info(f'--------{os.path.basename(__file__)} start--------')
        self.constant = Constant()
        self.sh_primary = CommonSH('PrimaryDbUser')
        self.PrimaryNode = Node('PrimaryDbUser')
        self.user_node = Node('Standby1DbUser')

    def test_system_internal_tools(self):
        LOG.info('--------step1:关闭正在运行的备机   expect:关闭成功--------')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl stop -D {macro.DB_INSTANCE_PATH} 
                '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        self.assertIn(self.constant.GS_CTL_STOP_SUCCESS_MSG, msg)

        LOG.info('----step2:指定正确数据库实例目录启动备机   expect:启动成功----')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl start -D {macro.DB_INSTANCE_PATH} -M standby; 
                '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        self.assertIn(self.constant.RESTART_SUCCESS_MSG, msg)

        LOG.info('--------step3:查看集群状态   expect:备机启动成功--------')
        time.sleep(5)
        status = self.sh_primary.get_db_cluster_status(param='detail')
        self.assertTrue(len(status.splitlines()) >= 10)
        self.assertIn('Standby Normal', status.splitlines()[-2])

    def tearDown(self):
        LOG.info('--------step4:启动备机   expect:成功--------')
        excute_cmd = f'''
                    source {macro.DB_ENV_PATH};
                    gs_ctl start -D {macro.DB_INSTANCE_PATH} -M standby; 
                '''
        LOG.info(excute_cmd)
        msg = self.user_node.sh(excute_cmd).result()
        LOG.info(msg)
        status = self.sh_primary.get_db_cluster_status(param='detail')
        self.assertTrue(len(status.splitlines()) >= 10)
        self.assertIn('Standby Normal', status.splitlines()[-2])
        LOG.info(f'--------{os.path.basename(__file__)} end--------')
